# Connecting from Tableau Desktop

{% hint style="info" %}
The instructions on this page are based on Tableau Desktop Professional Edition 2020.3.6.
{% endhint %}

## Supported Tableau Desktop Versions

The Windows version of Tableau Desktop Professional Edition is required to connect to Open Data Blend Analytics.

{% hint style="info" %}
We recommend using Tableau Desktop Professional Edition 2020.3.6 or later for the best experience.
{% endhint %}

## Installing the Analysis Services Client Libraries

We recommend installing the latest version of the Analysis Services OLE DB Provider (MSOLAP). This is available [here](https://docs.microsoft.com/en-us/analysis-services/client-libraries?view=asallproducts-allversions).

## Connecting to the Open Data Blend Analytics Server

In the Connect pane under the 'To a Server' section, click 'Microsoft Analysis Services'.

![](https://2828358319-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MKsnHi3Rf8E7kunYTJB%2F-MTv4WKdzmbpiP3m98zA%2F-MTvPezlh-5a9JVWZ4m7%2Fimage.png?alt=media\&token=518ed7dd-c1b5-42a7-81e4-204f0c575d39)

You will be prompted for the connection details.

<div align="left"><img src="https://2828358319-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MKsnHi3Rf8E7kunYTJB%2F-MTp3gAqAsg0R1AJMNvJ%2F-MTp7q5BMc03MJQy1CBF%2Fimage.png?alt=media&#x26;token=48df4f20-63ab-48c5-ac33-4623880af2af" alt=""></div>

Enter the following details then click 'Sign In':

**Server**: link://analytics.opendatablend.io

**Username:** Enter a blank space.

**Password:** Enter a blank space.

{% hint style="info" %}
Instead of 'link://analytics.opendatablend.io' for the server, you can also use 'powerbi://api.powerbi.com/v1.0/analytics.opendatablend.io/Open Data Blend Analytics'
{% endhint %}

You will be prompted to sign into your account. Use your [Analytics User](https://docs.opendatablend.io/open-data-blend-analytics/analytics-users) details and follow the additional prompts to complete the login.

<div align="left"><img src="https://2828358319-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MKsnHi3Rf8E7kunYTJB%2F-MUVH5PNOGqNygOqMllZ%2F-MUVKppRQKrrZ4FXhQO0%2Fimage.png?alt=media&#x26;token=269b73a4-04bb-480c-8993-84ea4b475cda" alt=""></div>

On the data source page, select 'Open Data Blend Analytics' for the database and 'Model' for the cube. Then click 'Sheet 1'.

![](https://2828358319-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MKsnHi3Rf8E7kunYTJB%2F-MkwbGzQJzzt7tadsqk5%2F-MkwcaJ8OZGzLVsAFRYI%2Ftableau-connection.png?alt=media\&token=d19b1b61-79e6-4193-acdd-589f152c45d1)

{% hint style="info" %}
If you want to work with only a subset of the model, you can choose one of the other cube names. For example, if you want to focus on analysing the prescribing data you would choose 'Prescribing'.
{% endhint %}

Now you can analyse the data.

![](https://2828358319-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MKsnHi3Rf8E7kunYTJB%2F-MTv4WKdzmbpiP3m98zA%2F-MTvU9w6DC98uwk1BMEy%2Fimage.png?alt=media\&token=90587402-325d-4d6e-9bcc-784609acaccc)

This is what the Open Data Blend Analytics experience looks like in Tableau Desktop.

![](https://2828358319-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MKsnHi3Rf8E7kunYTJB%2F-MbtfxPKVutzAHCbBBeB%2F-MbtgtMrZmmf41M4sgN_%2Fopen-data-blend-analytics-experience-tableau.gif?alt=media\&token=9342c7f7-2e8f-47bb-adcd-79d4bac50727)

## Using Tableau Desktop for Data Analysis

Guidance on how to analyse data in Tableau Desktop is beyond the scope of this documentation.&#x20;

You may find the following helpful:

* [Tableau Desktop and Web Authoring Help](https://help.tableau.com/current/pro/desktop/en-us/gettingstarted_overview.htm)
* [Tableau Public How-to Videos](https://public.tableau.com/en-us/s/resources)

## Open Data Blend Starter Files

We have created a set of Open Data Blend Starters which are files with a pre-configured connection to Open Data Blend Analytics. You can find the starter for Tableau Desktop [here](https://github.com/opendatablend/starters).